Mega Code Archive
System Packages
1) 3DES
2) 3DES_2KEY
3) A small buffer
4) AES128
5) AES192
6) AES256
7) An anonymous block program to create a pipe
8) An anonymous block program to delete a pipe
9) An Oracle9i Pipelined Table Function
10) Assign dbms_utility get_time to integer variable
11) Call dbms_lob write to write value to clob type value
12) Call dbms_output disable
13) Call dbms_output new_line to create a new line
14) Call dbms_output put_line to display text message
15) Call dbms_random normal to get a random number
16) Call dbms_sql describe_columns2 to get info for a column
17) Call dbms_utility get_time twice to time a statement in PL SQL
18) Calling a function which uses dynamic SQL from within an SQL statement
19) Catch different UTL_FILE related errors
20) Combine text and number in DBMS_OUTPUT PUT_LINE
21) Compile by version
22) COPY_FILE procedure enables you to copy binary files from one location to another
23) Dbms_alert signal
24) Dbms_alert waitone
25) Dbms_application_info set_client_info
26) DBMS_AQADM CREATE_QUEUE
27) DBMS_AQADM CREATE_QUEUE_TABLE
28) DBMS_AQADM START_QUEUE
29) Dbms_crypto hash
30) Dbms_crypto hash_sh1
31) DBMS_DEBUG probe_version
32) DBMS_FGA ADD_POLICY
33) DBMS_FLASHBACK ENABLE_AT_TIME
34) DBMS_JOB package
35) DBMS_LOB CREATETEMPORARY
36) DBMS_LOB ERASE
37) DBMS_LOB FREETEMPORARY
38) DBMS_LOB ISTEMPORARY
39) DBMS_LOB READ
40) DBMS_LOB SUBSTR
41) DBMS_LOB WRITE
42) Dbms_metadata get_ddl( TABLE, TABLENAME )
43) DBMS_OBFUSCATION_TOOLKIT des3decrypt
44) DBMS_OBFUSCATION_TOOLKIT des3encrypt
45) DBMS_OBFUSCATION_TOOLKIT des3getkey
46) DBMS_OBFUSCATION_TOOLKIT md5 and RAWTOHEX
47) Dbms_obfuscation_toolkit md5
48) Dbms_output enable
49) DBMS_OUTPUT GET_LINES
50) Dbms_output new_line
51) Dbms_output put
52) DBMS_PIPE PACK_MESSAGE
53) DBMS_PIPE UNPACK_MESSAGE
54) Dbms_pipe remove_pipe
55) Dbms_random value
56) DBMS_REDEFINITION START_REDEF_TABLE and execute DBMS_REDEFINITION FINISH_REDEF_TABLE
57) Dbms_repair create_action
58) Dbms_repair orphan_table
59) DBMS_ROWID ROWID_BLOCK_NUMBER(RowID)
60) DBMS_ROWID ROWID_RELATIVE_FNO(RowID)
61) DBMS_ROWID ROWID_RELATIVE_FNO(RowID),DBMS_ROWID ROWID_BLOCK_NUMBER(RowID)
62) DBMS_ROWID ROWID_ROW_NUMBER(RowID)
63) DBMS_ROWID ROWID_TO_RESTRICTED(RowID,0)
64) Dbms_rowid rowid_block_number(rowid) and ora_rowscn
65) Dbms_scheduler evaluate_calendar_string
66) DBMS_SQL BIND_VARIABLE_CHAR
67) DBMS_SQL NATIVE
68) DBMS_SQL package
69) DBMS_SQL PARSE and DBMS_SQL EXECUTE
70) Dbms_sql varchar2_table type variable
71) Dbms_stats drop_stat_table, dbms_stats create_stat_table,dbms_stats delete_system_stats
72) Dbms_stats gather_schema_stats
73) Dbms_stats gather_table_stats
74) DBMS_STATS GET_SYSTEM_STATS
75) Dbms_stats import_system_stats
76) Dbms_stats objectTab
77) Dbms_stats set_table_stats( user, EMP, numrows = 100000 )
78) Dbms_stats set_table_stats( user, myTable1, numrows = 10000000, numblks = 1000000 )
79) DBMS_TRACE PLSQL_TRACE_VERSION
80) DBMS_UTILITY analyze_schema
81) Dbms_utility format_error_stack
82) Dbms_utility get_parameter_value
83) DBMS_WARNING SET_WARNING_SETTING_STRING(ENABLE
84) Dbms_xmlquery getxml
85) Dbms_xmlschema registerSchema
86) Define an anonymous block to populate the local private pipe
87) Delete all table and index statistics in your schema
88) Demonstrate DES3 encryption
89) Demonstrates DBMS_APPLICATION_INFO and its two procedures
90) Demonstrates the use of DBMS_UTILITY TABLE_TO_COMMA and DBMS_UTILITY COMMA_TO_TABLE
91) Displaying Hello World! to the Screen
92) Drop the supplied table using dynamic SQL
93) Dynamic select statement and row fetch
94) Dynamic sql statement with variable binding
95) Enable tracing of all calls and all exceptions
96) Enter flashback mode, going back 10 minutes
97) Execute dbms_lock sleep(42)
98) EXECUTE DBMS_OUTPUT ENABLE(10000)
99) Execute PLSQL block
100) Execute the DBMS_APPLICATION_INFO package
101) Executing PLSQL Blocks and use BIND_VARIABLE to bind variable
102) Executing Queries and use DBMS_SQL COLUMN_VALUE to map value
103) Extract system stats from your user table or data dictionary (sys aux_Stats$)
104) First DBMS_SQL Example
105) submit TempInsert as a job
106) Htp package demo
107) Illustrate the importance of setting out_value_size
108) Illustrates a DDL statement which is built dynamically from the procedure parameters
109) Illustrates the interaction of roles and dynamic SQL
110) Insert random numbers into a table
111) Insert random value to table
112) Leave Flashback mode
113) Load the data into table myTable You may use any valid number for column c1s data
114) Mod(abs(dbms_random random),50000)+1
115) Multiblock readtime in ms
116) Non-Query DML and DDL Statements
117) ORA_CLIENT_IP_ADDRESS returns the client IP address as a VARCHAR2 datatype
118) ORA_DES_ENCRYPTED_PASSWORD returns the DES-encrypted password as a VARCHAR2 datatype
119) ORA_DICT_OBJ_NAME returns an object name as a VARCHAR2 datatype
120) ORA_DICT_OBJ_NAME_LIST
121) ORA_DICT_OBJ_OWNER returns an owner of the object acted upon by the event as a VARCHAR2 datatype
122) ORA_DICT_OBJ_OWNER_LIST returns the number of elements in the list indexed by a PLS_INTEGER datatype
123) ORA_DICT_OBJ_TYPE returns the datatype of the dictionary object changed by the event as a VARCHAR2 datatype
124) ORA_GRANTEE returns the number of elements in the list indexed by a PLS_INTEGER datatype
125) ORA_INSTANCE_NUM returns the current database instance number as a NUMBER datatype
126) ORA_IS_ALTER_COLUMN returns a true or false value as a BOOLEAN datatype
127) ORA_IS_CREATING_NESTED_TABLE returns a true or false value as a BOOLEAN datatype when you create a table with a nested tab
128) ORA_LOGIN_USER function returns the current schema name as a VARCHAR2 datatype
129) ORA_PRIVILEGE_LIST returns the number of elements in the list indexed by a PLS_INTEGER datatype
130) ORA_SERVER_ERROR returns an error number as a NUMBER datatype
131) ORA_SERVER_ERROR_MSG returns an error message text as a VARCHAR2 datatype
132) ORA_SYSEVENT function returns the system event that was responsible for firing the trigger as a VARCHAR2 datatype
133) ORA_WITH_GRANT_OPTION returns a true or false value as a BOOLEAN datatype
134) ORA-00918
135) ORA-00934
136) ORA-00979
137) ORA-01403
138) ORA-01422
139) ORA-01426
140) ORA-01839
141) ORA-06502
142) ORA-06503
143) ORA-14551
144) Outln_pkg drop_by_cat
145) Output Visual line break
146) Pass a query statement to a stored procedure
147) Pass where clause to a stored procedure
148) Performace difference between simple parameter and collection parameter
149) Random string with dbms_random string
150) RC4
151) Receiving an alert using DBMS_ALERT
152) Register interest in an alert
153) Remove a procedure from the queue after 5 executions
154) Remove your registered interest in a DBMS_ALERT
155) ROUND a DBMS_RANDOM VALUE
156) Round a random value from dbms_random value
157) Round dbms_utility get_time
158) Run a DBMS_PIPE RECEIVE_MESSAGE call to empty the local buffer
159) Run DBMS_STATS GATHER_SCHEMA_STATS to collect stats for all of your tables and indexes
160) Save data in a cursor to a file
161) Save value returned from DBMS_METADATA GET_XML to xmltype
162) Seed a random value with dbms_random seed
163) SELECT DBMS_WARNING GET_WARNING_SETTING_STRING() WARNING_LEVEL FROM dual
164) Sending an alert through DBMS_ALERT
165) Simple Procedure with SUBMIT
166) Submit job to change password
167) TEXT_IO package
168) The ORA_IS_SERVERERROR returns a true or false value as a BOOLEAN datatype when the error is on the error stack
169) This block demonstrates DBMS_LOB GETLENGTH
170) This block demonstrates the use of DBMS_LOB COPY
171) This script deletes a pipe if it exists in the context of the current session, then recreates it
172) This script demonstrates DBMS_UTILITY NAME_TOKENIZE
173) This script demonstrates the DBMS_OUTPUT package
174) This script illustrates DBMS_SESSION RESET_PACKAGE
175) This script illustrates the use of the DBMS_RANDOM package
176) This script tests the DBMS_LOB LOADFROMFILE procedure
177) This script unpacks the local buffer
178) Time to commit
179) Timing Package function call
180) Timing Per Thousand Records Processed (in secs)
181) Trunc a random value from dbms_random value
182) Use DBMS_APPLICATION_INFO and USERENV() in building a publish-and-subscribe implementation
183) Use dbms_job submit to call execute immediate
184) Use dbms_lob compare to compare
185) Use dbms_lob compare to compare clob type value with offset
186) Use dbms_lob for load clob data from file
187) Use dbms_lob getchunksize to get the clob column size
188) Use DBMS_LOB GETLENGTH to get the length of a clob type variable
189) Use dbms_lob writeappend to append value to clob type value
190) Use DBMS_OUTPUT PUT_LINE to output clob data
191) Use DBMS_OUTPUT PUT_LINE to output the table collection indexed by BINARY_INTEGER
192) Use DBMS_PIPE PACK_MESSAGE in a trigger
193) Use DBMS_PIPE package to receive a message
194) Use DBMS_PIPE package to send a message
195) Use dbms_random string to create random string
196) Use dbms_space to show space
197) Use dbms_sql bind_array to bind array to a cursor
198) Use dbms_sql bind_variable to bind variable
199) Use dbms_sql bind_variable, dbms_sql execute to insert value to a table
200) Use dbms_sql open_cursor create a cursor
201) Use dbms_sql parse to bind a select statement to a cursor
202) Use dbms_sql to process query, cursor and value
203) Use DBMS_SQL with the RETURNING clause
204) Use DBMS_UTILITY FORMAT_ERROR_STACK in a SERVERERROR trigger
205) Use dbms_utility get_time to do performace check
206) Use dbms_utility to time
207) Use UTL_FILE FCLOSE to close a file
208) Use UTL_FILE PUT_LINE to write a line of text to a file
209) Use UTL_FILE to print a transacript to a file
210) Use UTL_FILE to read from a file and insert into the lecturer table
211) Use utl_file fopen to open a file
212) Use UTL_HTTP package to load a website to a table
213) Use UTL_INADDR package to get the host name and IP address
214) Use UTL_SMTP package to send out an email
215) Use UTL_TCP package
216) Use xdbURIType
217) Using DBMS_OUTPUT to See the Assigned Job Number
218) Using the DBMS_REPAIR CHECK_OBJECT Procedure
219) Using the DBMS_REPAIR FIX_CORRUPT_BLOCKS Procedure
220) Using the SUBMIT Procedure
221) UTL_COMPRESS package lets you compress and decompress binary data (RAW, BLOB, and BFILE)
222) Utl_i18n string_to_raw
223) UTL_MAIL package enables you to send and receive e-mail, along with attachments, CC, BCC, and return receipt features
224) Utl_raw bit_and
225) Utl_raw bit_complement
226) Utl_raw bit_or
227) Utl_raw bit_xor
228) Utl_raw cast_from_binary_integer
229) Utl_raw cast_from_number
230) Utl_raw cast_to_binary_integer
231) Utl_raw cast_to_number
232) Utl_raw cast_to_raw
233) Utl_raw cast_to_raw( Cameron )
234) Utl_raw cast_to_varchar2( 43616D65726F6E)
235) Utl_raw compare( 010203, 01020304, 04 )
236) Utl_raw compare( 01050304, 01020304 )
237) Utl_raw concat( 9, 0102, ff, 0a2b )
238) Utl_raw copies( 010203, 4 )
239) Utl_raw length( 43616D65726F6E)
240) Utl_raw overlay( aabb, 010203 )
241) Utl_raw overlay( aabb, 010203, 2 )
242) Utl_raw overlay( aabb, 010203, 2, 1 )
243) Utl_raw overlay( aabb, 010203, 5 )
244) Utl_raw overlay( aabb, 010203, 5, 1, FF )
245) Utl_raw reverse( 0102030405 )
246) Utl_raw substr( 0102030405, 3, 2 )
247) Utl_raw translate( 0102030405, 0203, 06 )
248) Utl_raw transliterate( 010203040502, 0809, 01020304, 0a )
249) Utl_raw xrange( 01, 11 )
250) Utl_raw xrange( fa, 06 )
251) Where rowid = dbms_rowid rowid_create(1,49627,7,138,0)
252) Wrapping PLSQL Stored Programs with dbms_ddl create_wrapped
253) Writing Hello World! to a File